package com.jy.adscm.spss.mapper.mysql;

import java.util.List;

import com.baomidou.mybatisplus.mapper.BaseMapper;

import com.jy.adscm.spss.bean.Yl_Materialdetail;
import com.jy.adscm.spss.bean.Zjk_Middlelibrarydetail;
import com.jy.adscm.spss.bean.Zjk_MiddlelibrarydetailQuery;
import org.apache.ibatis.annotations.Param;



public interface Zjk_MiddlelibrarydetailMapper extends BaseMapper<Zjk_Middlelibrarydetail> {
    int countByExample(Zjk_MiddlelibrarydetailQuery example);

    int deleteByExample(Zjk_MiddlelibrarydetailQuery example);

    int deleteByPrimaryKey(String did);


    int insertSelective(Zjk_Middlelibrarydetail record);

    List<Zjk_Middlelibrarydetail> selectByExample(Zjk_MiddlelibrarydetailQuery example);

    Zjk_Middlelibrarydetail selectByPrimaryKey(String did);

    int updateByExampleSelective(@Param("record") Zjk_Middlelibrarydetail record, @Param("example") Zjk_MiddlelibrarydetailQuery example);

    int updateByExample(@Param("record") Zjk_Middlelibrarydetail record, @Param("example") Zjk_MiddlelibrarydetailQuery example);

    int updateByPrimaryKeySelective(Zjk_Middlelibrarydetail record);

    int updateByPrimaryKey(Zjk_Middlelibrarydetail record);
    
    List<Zjk_Middlelibrarydetail> getByNameAndAll(@Param("RESOURCENAME") String RESOURCENAME);
    
    List<String> getOnlyBachNum(@Param("RESOURCENAME") String RESOURCENAME);
    /**
     * 获取中间库入库于出库差值
     * @return
     */
    List<Zjk_Middlelibrarydetail> getLjDiff();
  /**
   * 获取中间库零件差值的唯一批号
   * @return
   */
    List<String> getByDiffOnly();
    /**
     * 获取原料库入库于出库差值
     * @return
     */
    List<Yl_Materialdetail> getYlkLjDiff();
    /**
     * 获取中间库零件差值的唯一批号
     * @return
     */
    List<String> getYlkByDiffOnly();
    
    List<Zjk_Middlelibrarydetail> getDiffAll();
}